#coding:utf8
'''
Created on 2017/7/11
19:21
@author: meed
'''

query = """

 UPDATE cmdb SET assets_number="efun-cloudAWS-00879", IDC_type="AWS", room_info="亚马逊法兰克福",
                    cabinet_info="None", serial_number="i-0699643449b879d08", model_number="c3.xlarge",
                    wan_ip="52.28.68.123", ip="10.20.32.156", remote_ip="无", cmdb.status="使用", assets_user="亚欧",
                    business_type="None", business_name="德语-雷霆舰队", detailed_action="ltjd-de-gs1",
                    upline_time="2016-06-07", downline_time="None", osystem="centos 6.5 x86_64", source="租用",
                    deadline="None", contract_number="无", price="0.258", monthly_fee="191.952",
                    up_time="2016-06-07", down_time="None", usage_days="31", monthbilling="191.952",
                    cmdb.comment="None", cpu="1核--4G", mem="4G", cmdb.disk="200G"
                    WHERE id="6764"
"""

query = query.replace('downline_time="None",', '')

print query
